/*
 Navicat Premium Data Transfer

 Source Server         : sql server
 Source Server Type    : SQL Server
 Source Server Version : 16001135 (16.00.1135)
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001135 (16.00.1135)
 File Encoding         : 65001

 Date: 06/12/2024 21:52:00
*/


-- ----------------------------
-- Table structure for 考生初试成绩表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[考生初试成绩表]') AND type IN ('U'))
	DROP TABLE [dbo].[考生初试成绩表]
GO

CREATE TABLE [dbo].[考生初试成绩表] (
  [examnumber] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [englishscore] float(53)  NULL,
  [mathscore] float(53)  NULL,
  [majorscore] float(53)  NULL,
  [politicalscore] float(53)  NULL
)
GO

ALTER TABLE [dbo].[考生初试成绩表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 考生初试成绩表
-- ----------------------------
INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'001', N'78.5', N'89', N'85.5', N'70.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'002', N'75', N'76', N'82.5', N'68')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'003', N'80.5', N'90', N'84', N'72')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'004', N'85', N'87', N'86.5', N'75')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'005', N'79.5', N'83.5', N'87', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'006', N'73', N'80.5', N'83', N'69')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'007', N'77.5', N'81.5', N'85', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'008', N'82', N'84.5', N'88.5', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'009', N'88', N'86', N'90', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'010', N'79', N'88', N'86', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'011', N'76.5', N'82', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'012', N'81', N'85', N'87.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'013', N'84.5', N'87.5', N'89', N'75.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'014', N'78', N'83', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'015', N'75.5', N'79.5', N'82', N'67.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'016', N'80', N'84', N'86', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'017', N'83.5', N'85.5', N'88', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'018', N'86', N'89', N'91', N'76.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'019', N'77', N'81', N'83.5', N'69.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'020', N'74', N'78', N'80.5', N'66')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'021', N'79.5', N'82.5', N'85', N'72')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'022', N'82', N'85', N'87.5', N'73.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'023', N'85', N'87', N'89.5', N'75')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'024', N'87.5', N'89.5', N'92', N'77.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'025', N'78.5', N'83.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'026', N'76', N'80.5', N'83', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'027', N'79', N'84', N'86.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'028', N'81.5', N'86', N'88.5', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'029', N'84', N'87.5', N'90', N'75.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'030', N'77.5', N'82', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'031', N'75', N'79', N'81.5', N'67')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'032', N'80', N'83.5', N'86', N'72')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'033', N'83', N'85.5', N'88', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'034', N'85.5', N'88', N'90.5', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'035', N'79', N'84.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'036', N'76.5', N'81', N'83.5', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'037', N'78', N'82.5', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'038', N'80.5', N'85', N'87.5', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'039', N'83', N'86.5', N'89', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'040', N'86', N'89', N'91.5', N'77')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'041', N'78.5', N'83', N'85.5', N'70.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'042', N'75', N'79.5', N'82', N'67.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'043', N'77.5', N'81.5', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'044', N'80', N'84', N'86.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'045', N'82.5', N'85.5', N'88', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'046', N'85', N'88', N'90.5', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'047', N'79', N'83.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'048', N'76.5', N'81', N'83.5', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'049', N'78', N'82.5', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'050', N'80.5', N'85', N'87.5', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'051', N'83', N'86.5', N'89', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'052', N'86', N'89', N'91.5', N'77')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'053', N'78.5', N'83', N'85.5', N'70.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'054', N'75', N'79.5', N'82', N'67.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'055', N'77.5', N'81.5', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'056', N'80', N'84', N'86.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'057', N'82.5', N'85.5', N'88', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'058', N'85', N'88', N'90.5', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'059', N'79', N'83.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'060', N'76.5', N'81', N'83.5', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'061', N'78', N'82.5', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'062', N'80.5', N'85', N'87.5', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'063', N'83', N'86.5', N'89', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'064', N'86', N'89', N'91.5', N'77')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'065', N'78.5', N'83', N'85.5', N'70.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'066', N'75', N'79.5', N'82', N'67.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'067', N'77.5', N'81.5', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'068', N'80', N'84', N'86.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'069', N'82.5', N'85.5', N'88', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'070', N'85', N'88', N'90.5', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'071', N'79', N'83.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'072', N'76.5', N'81', N'83.5', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'073', N'78', N'82.5', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'074', N'80.5', N'85', N'87.5', N'73')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'075', N'83', N'86.5', N'89', N'74.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'076', N'86', N'89', N'91.5', N'77')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'077', N'78.5', N'83', N'85.5', N'70.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'078', N'75', N'79.5', N'82', N'67.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'079', N'77.5', N'81.5', N'84.5', N'70')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'080', N'80', N'84', N'86.5', N'72.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'081', N'82.5', N'85.5', N'88', N'74')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'082', N'85', N'88', N'90.5', N'76')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'083', N'79', N'83.5', N'86', N'71.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'084', N'76.5', N'81', N'83.5', N'68.5')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'085', N'78', N'82.5', N'85', N'71')
GO

INSERT INTO [dbo].[考生初试成绩表] ([examnumber], [englishscore], [mathscore], [majorscore], [politicalscore]) VALUES (N'086', N'80.5', N'85', N'87.5', N'73')
GO


-- ----------------------------
-- Foreign Keys structure for table 考生初试成绩表
-- ----------------------------
ALTER TABLE [dbo].[考生初试成绩表] ADD CONSTRAINT [FK_考生初试成绩表_考生信息表] FOREIGN KEY ([examnumber]) REFERENCES [dbo].[考生信息表] ([examnumber]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

